CREATE EXTERNAL TABLE jms_dm.dm_sqs_receiver_user_order_complaint_cnt_dt(
  receiver_mobile_phone string COMMENT '电话号', 
  receiver_name string COMMENT '收件人姓名', 
  receiver_province_name string COMMENT '收件省name', 
  receiver_province_id string COMMENT '收件省id', 
  receiver_city_name string COMMENT '收件城市id', 
  receiver_city_id string COMMENT '收件城市name', 
  receiver_area_name string COMMENT '收件区name', 
  receiver_area_id string COMMENT '收件区id', 
  waybill_cnt int COMMENT '进三个月快件数量     ', 
  complaint_cnt int COMMENT '投诉量', 
  qxt_waybill_cnt int COMMENT '七星潭进三个月快件数量', 
  thd_waybill_cnt int COMMENT '桃花岛进三个月快件数量', 
  zjs_waybill_cnt int COMMENT '紫金山进三个月快件数量', 
  other_waybill_cnt int COMMENT '紫金山进三个月快件数量', 
  is_new_user int COMMENT '是否新用户', 
  complaint_time timestamp COMMENT '最新投诉时间', 
  input_time timestamp COMMENT '最新订单录入时间', 
  qxt_complaint_cnt int COMMENT '七星潭进三个月投诉量', 
  thd_complaint_cnt int COMMENT '桃花岛进三个月投诉量', 
  zjs_complaint_cnt int COMMENT '紫金山进三个月投诉量', 
  other_complaint_cnt int COMMENT '紫金山进三个月投诉量', 
  date_time date COMMENT '查询日期')
COMMENT '临时表'
PARTITIONED BY (dt string COMMENT '日期分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_receiver_user_order_complaint_cnt_dt'
TBLPROPERTIES ('discover.partitions' = 'false',  'parquet.column.index.access' = 'true');